What is the way for finding out whether a table exists in the Microsoft Access database?

Question

Anonymous User · Answer

This is solve my problem!Thanks Avadhesh

AVADHESH PATEL · Answer

hi ashish,
given query solve your problem....Dim db As Database
Dim i As Integer
and and and and Set db = DBEngine.Workspaces(0).Databases(0)
and and and and fExistTable = False
and and and and db.TableDefs.Refresh
and and and and For i = 0 To db.TableDefs.Count - 1
and and and and and and and and If strTableName =
db.TableDefs(i).Name Then
and and and and and and and and and and and and 'Table
Exists
and and and and and and and and and and and and fExistTable
= True
and and and and and and and and and and and and Exit
For
and and and and and and and and End If
and and and and Next i

forum

What is the way for finding out whether a table exists in the Microsoft Access database?

Anonymous User

Can you answer this question?

2 Answers

Liked By